SSRS Report embeds exportable iMIS reports

The SSRS Report iPart makes it possible for you to display the formatted results of an iMIS report on any page where you place it. The SSRS iPart leverages the version 10 ReportViewer, which supports IE8 natively and adds the convenience of a Print button on its toolbar. You can add the SSRS iPart to any content page: select add content, open the Utility folder, and choose the content type SSRS Report.

The iPart lets you choose whether to include export buttons for PDF and Excel versions of the report. When you configure the iPart, you specify the Document system path to Reporting Services Report , which binds an RDL template (Reporting Services Template ) to a specific IQA query with the parameter settings you choose. Browse to $/Samples/ReportingServices to experiment with sample files.

Editor-free report creation

You can take advantage of the dynamic SSRS reporting feature of IQA to generate many of the reports you need, without using any report editors:

1.  Edit your query and click Report to generate a report that is formatted dynamically using the settings you control through SystemConfig parameters.

2.  Select Save Report Definition to iMIS, which generates your Reporting Services Template ([QueryName].rdl) and Reporting Services Report ([Query Name]).

3.  Now you can create a content record with an SSRS iPart to display your new report, and deploy the content into your site through a new navigation item, tagging, or other method.

Subreports

If you design your own RDL source files, you can upload them into iMIS as new templates, create reports (which link templates to queries), and display those reports with SSRS iParts. Since SSRS subreports are stored as separate RDL files that the main report references, you just upload them into iMIS separately, grouping them in the same Document System folder.

Direct URL calls to run one-off reports

Content Management also supports direct calls to SSRS reports from your web page code, so that you can create one-off reports you may need. For example, to add a Print Detail button on a Batch details page, you would call a content item (@/iMIS/Accounting/BatchDetailReport) and pass it a parameter (Batch Number) as a URL parameter. For code samples, see Reporting Services.